Search:

Tag: index and match

Page 2 of 4 1 2 3 4

Search: Replies Views Search took 0.00 seconds.

  1. [SOLVED] INDEX/MATCH error cannot be explained

    Started by lsargent‎, 10-28-2016 07:20 PM
    index & match, index + match, index and match, index and match function
    • 3,935
    Last Post: 01-05-2017 07:07 PM
    by lsargent  Go to last post

    Forum:
    Excel Formulas & Functions

  2. Indexing and Matching (I Think??) Against Multiple Worksheets Using Multiple Criterion

    Started by eNinjaInTraining‎, 10-21-2016 10:04 PM
    index, index & match, index and match, match, multiple spreadsheets 1 Attachment(s)
    • 1,084
    Last Post: 10-26-2016 09:00 PM
    by eNinjaInTraining  Go to last post

    Forum:
    Excel Formulas & Functions

  3. Identify "groups" based on identical entries in two columns, and count a third column

    Started by Rooster907‎, 10-19-2016 07:28 PM
    array, count and if, index and match
    • 592
    Last Post: 10-19-2016 07:52 PM
    by alansidman  Go to last post

    Forum:
    Excel Formulas & Functions

  4. VLOOKUP and searching for largest value

    Started by bikemaniac‎, 08-25-2016 09:27 AM
    index and match, vlookup
    • 1,194
    Last Post: 08-26-2016 03:12 AM
    by bikemaniac  Go to last post

    Forum:
    Excel Formulas & Functions

  5. INDEX MATCH with 1 conditions within a range

    Started by gerald.lebret‎, 05-27-2016 12:59 PM
    formula, index & match, index and match 2 Attachment(s)
    • 945
    Last Post: 06-09-2016 06:04 PM
    by gerald.lebret  Go to last post

    Forum:
    Excel Formulas & Functions

  6. [SOLVED] show cell blank instead of 0 or error after index match formula

    Started by tabkaz‎, 04-22-2016 08:45 AM
    iferror, index and match, sumproduct
    • 4,778
    Last Post: 04-23-2016 01:46 AM
    by tabkaz  Go to last post

    Forum:
    Excel Formulas & Functions

  7. Perform Logical Equivilent of Index Match Array look up with multiple criteria in VBA

    Started by MichaelDoughertyJr‎, 03-25-2016 04:18 PM
    array formula, date as criteria, index and match, vba
    • 902
    Last Post: 03-28-2016 04:03 PM
    by AlphaFrog  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  8. [SOLVED] Formula for volatile date range

    Started by chococ‎, 01-21-2016 11:41 AM
    date as criteria, index and match, sum and if, sum and ifs 1 Attachment(s)
    • 807
    Last Post: 01-21-2016 02:02 PM
    by chococ  Go to last post

    Forum:
    Excel Formulas & Functions

  9. [SOLVED] I need to lookup info on 1 spreadsheet and if criteria is met paste on another spreadsheet

    Started by shina67‎, 01-13-2016 09:18 AM
    index & if, index and match, lookup and, string array 2 Attachment(s)
    • 619
    Last Post: 01-13-2016 04:13 PM
    by JeteMc  Go to last post

    Forum:
    Excel Formulas & Functions

  10. Increase criteria for {=INDEX(A:A,MATCH(LARGE(IF(B:B=52,C:C),1),C:C,0))}

    Started by albanhac‎, 01-13-2016 07:05 AM
    formulas, index and match 6 Attachment(s)
    • 1,188
    Last Post: 01-14-2016 07:31 PM
    by FDibbins  Go to last post

    Forum:
    Excel Formulas & Functions

  11. [SOLVED] INdex/Match Formula

    Started by gladston‎, 12-21-2015 12:05 PM
    index, index & match, index and match, match, match and index 2 Attachment(s)
    • 883
    Last Post: 12-28-2015 08:52 AM
    by gladston  Go to last post

    Forum:
    Excel General

  12. Formula to Identify Named Range

    Started by RVA_ExcelMonkey‎, 11-30-2015 03:30 PM
    dynamic array formula, index and match, named array 2 Attachment(s)
    • 996
    Last Post: 12-02-2015 04:13 PM
    by RVA_ExcelMonkey  Go to last post

    Forum:
    Excel Formulas & Functions

  13. [SOLVED] Index Match with Multiple Criteria and Multiple Columns

    Started by KAVS101‎, 09-29-2015 02:16 PM
    index & match, index and match, multiple criteria 1 Attachment(s)
    • 2,224
    Last Post: 04-23-2016 06:39 AM
    by John90  Go to last post

    Forum:
    Excel Formulas & Functions

  14. [SOLVED] Index and Match Not working in particular Row

    Started by barathsoft‎, 08-24-2015 07:00 AM
    formula, index and match, vba / macro 1 Attachment(s)
    • 592
    Last Post: 08-24-2015 11:10 PM
    by barathsoft  Go to last post

    Forum:
    Excel Formulas & Functions

  15. Excel 2007 Combo Box - Cell Link - Value Missing

    Started by soundspinner‎, 05-14-2015 05:38 PM
    combo box, combo box list, combo boxes, index and match, value not available
    • 805
    Last Post: 05-15-2015 06:00 PM
    by soundspinner  Go to last post

    Forum:
    Excel Formulas & Functions

  16. Index/Match in VBA

    Started by Justmegan93‎, 04-29-2015 05:03 AM
    formatting cells from vba, formulas, index and match, user defined function, vba 2 Attachment(s)
    • 616
    Last Post: 04-29-2015 09:38 AM
    by Justmegan93  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  17. [SOLVED] Refer to Excel workbook by path, based on cell value data

    Started by cornfedtm‎, 12-26-2014 11:21 PM
    formula, index and match, vlookup 1 Attachment(s)
    • 1,351
    Last Post: 12-27-2014 11:10 PM
    by alansidman  Go to last post

    Forum:
    Excel Formulas & Functions

  18. [SOLVED] Index & Match with Multiple criteria

    Started by dfaidley‎, 11-09-2014 09:05 PM
    defined range, index and if, index and match, index if small array, schedule generator 1 Attachment(s)
    • 1,032
    Last Post: 11-10-2014 12:53 PM
    by JBeaucaire  Go to last post

    Forum:
    Excel General

  19. [SOLVED] Why has Index Match array slowed calculation of spreadsheet to 1.5 hours

    Started by carrach‎, 09-19-2014 11:15 AM
    array formula, excel_2007, index & match, index and match, slow calculation 5 Attachment(s)
    • 5,524
    Last Post: 10-11-2014 03:15 AM
    by kvsrinivasamurthy  Go to last post

    Forum:
    Excel Formulas & Functions

  20. Index(Match function

    Started by BS22ME‎, 08-27-2014 05:18 PM
    index and match 1 Attachment(s)
    • 481
    Last Post: 08-27-2014 07:18 PM
    by micope21  Go to last post

    Forum:
    Excel Formulas & Functions

  21. [SOLVED] Transferring data from one column to another when it matches two conditions

    Started by emma.smith137‎, 08-27-2014 07:15 AM
    formula, index and match 3 Attachment(s)
    • 468
    Last Post: 08-27-2014 07:43 AM
    by Glenn Kennedy  Go to last post

    Forum:
    Excel Formulas & Functions

  22. Find nearest peak value and corresponding time

    Started by KFranklin‎, 08-18-2014 07:24 AM
    index and match, index if small array, min/max if 3 Attachment(s)
    • 911
    Last Post: 08-18-2014 10:36 AM
    by KFranklin  Go to last post

    Forum:
    Excel Formulas & Functions

  23. [SOLVED] Formula for obtaining a list of unique values but not including values which contain "IC"

    Started by Geoff.‎, 08-14-2014 05:37 PM
    formula, index and match, unique list 5 Attachment(s)
    • 2,936
    Last Post: 09-09-2014 05:37 PM
    by Geoff.  Go to last post

    Forum:
    Excel Formulas & Functions

  24. [SOLVED] Need quick help with lookup with multiple criteria

    Started by rjc88‎, 08-05-2014 11:09 AM
    excel 07, excel lookup, index and match 2 Attachment(s)
    • 614
    Last Post: 08-05-2014 03:05 PM
    by rjc88  Go to last post

    Forum:
    Excel Formulas & Functions

  25. Pull Values from List Exluding Matching Values in Second List

    Started by sskgintl‎, 07-15-2014 09:45 PM
    index and match, multiple lists 1 Attachment(s)
    • 551
    Last Post: 07-16-2014 09:29 PM
    by sskgintl  Go to last post

    Forum:
    Excel Formulas & Functions

  26. [SOLVED] Search multpile criteria to get a result

    Started by Beach Walker‎, 07-07-2014 08:53 PM
    array, formula, index, index and match 2 Attachment(s)
    • 787
    Last Post: 07-07-2014 09:25 PM
    by azumi  Go to last post

    Forum:
    Excel General

  27. Index/Match with Header and Vertical data

    Started by asmith9947‎, 06-12-2014 11:16 AM
    index, index & match, index and match, match, vlookup 3 Attachment(s)
    • 837
    Last Post: 06-13-2014 10:56 AM
    by asmith9947  Go to last post

    Forum:
    Excel Formulas & Functions

  28. Calculate number of idol hours

    Started by jmcconville18‎, 06-04-2014 02:47 PM
    difference between time, hours, index & match, index and match, utilization 6 Attachment(s)
    • 1,893
    Last Post: 06-06-2014 10:25 AM
    by jmcconville18  Go to last post

    Forum:
    Excel General

  29. Index and Match

    Started by jondrasek‎, 05-21-2014 10:44 AM
    index and match 2 Attachment(s)
    • 706
    Last Post: 05-21-2014 05:54 PM
    by FDibbins  Go to last post

    Forum:
    Excel General

  30. Keep returns from duplicating (softball batting lineup based on stats)

    Started by BARENTINEMATT‎, 05-08-2014 01:38 AM
    duplicate data in rows, index and match, return duplicates, rosters 2 Attachment(s)
    • 1,281
    Last Post: 05-08-2014 08:48 PM
    by BARENTINEMATT  Go to last post

    Forum:
    Excel General

  31. [SOLVED] Make an Index/Match Sum Array with wildcards

    Started by TheAlchemyst‎, 04-25-2014 04:32 PM
    array formula, index and match, wildcards 2 Attachment(s)
    • 1,936
    Last Post: 04-28-2014 06:48 PM
    by FDibbins  Go to last post

    Forum:
    Excel Formulas & Functions

  32. [SOLVED] Importing selected rows from one datasheet to another using conditions

    Started by PJR‎, 04-22-2014 10:14 AM
    condition formula results, condition if, index & if, index and match 3 Attachment(s)
    • 1,470
    Last Post: 04-23-2014 01:49 PM
    by PJR  Go to last post

    Forum:
    Excel General

  33. Conditional INDEX MATCH

    Started by PJR‎, 04-10-2014 11:53 AM
    condional counting, condition, index & if, index and match 2 Attachment(s)
    • 780
    Last Post: 04-10-2014 03:20 PM
    by AlKey  Go to last post

    Forum:
    Excel Formulas & Functions

  34. [SOLVED] Trying to pick a result from a table

    Started by mrvp‎, 04-07-2014 04:21 PM
    index and match, results in excel, table 1 Attachment(s)
    • 651
    Last Post: 04-07-2014 04:54 PM
    by mrvp  Go to last post

    Forum:
    Excel Formulas & Functions

  35. I am trying to look up text and return a value.

    Started by vagonzalez‎, 03-24-2014 05:23 PM
    index and match, look up data, look up text in cell, search and match data, vlookup arguments 2 Attachment(s)
    • 641
    Last Post: 04-15-2014 11:46 AM
    by vagonzalez  Go to last post

    Forum:
    Excel Formulas & Functions

Results 36 to 70 of 121
Page 2 of 4 1 2 3 4

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1